This spreadsheet is used to generate individual QLAs from a whole class QLA. You just copy and paste in the question number, marks and question subject, along with the class scores and it will create individual sheets for students to then rate using a RAG system. The individual QLAs are designed to be 2 per page of A4. The columns auto-resize during the creation of the sheets so be careful if using full names, as it may mean that one sheet is wider than the rest which can cause issues when cutting!

The KOAS is a way of organising the life of a busy teacher - it was originally built to create seating plans, but now also includes sections for tracking student data, a markbook, homework submissions, lesson logs and a timetable and calendar page as well as individual sheets for each class you teach. v2.01 is massively improved over the original - this can be re-used year on year and the calendar feature is designed so that it can be customised to any academic year. Watch the videos to see how it works and how it has made me more organised and efficient when planning and teaching.